{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Multiple Zone","100% OA","Single Zone","Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":31,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":309,"n_cols":17,"rows_kept":309,"cut":false,"hidden":false,"merged":[[113,2,113,5],[73,2,74,5],[73,6,73,7],[73,8,73,9],[73,10,74,10],[58,2,58,4],[45,5,45,9],[46,5,46,9],[47,5,47,9],[48,5,48,9],[49,5,49,9],[55,2,55,4],[50,5,50,9],[51,5,51,9],[56,2,56,4],[57,2,57,4],[43,5,43,9],[44,5,44,9],[2,4,2,10],[5,4,5,7],[28,4,28,10],[35,4,35,10],[32,4,32,10],[21,4,21,8],[73,13,74,13],[41,2,41,4],[41,5,41,9],[42,2,42,4],[43,2,43,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[48,2,48,4],[49,2,49,4],[50,2,50,4],[51,2,51,4],[67,2,67,9],[59,2,59,4],[42,5,42,9],[68,2,68,9],[69,2,69,9],[60,2,60,4],[61,2,61,4],[65,2,65,9],[66,2,66,9]]}
[]
[]
[null,null,null,null,"Minimum Indoor Air Quality Performance Calculator\nLEED 2009, v4, and v4.1 EQ Prerequisite Minimum Indoor Air Quality Performance"]
[]
[null,null,null,null,"Step 1."]
[null,null,null,null,"Enable macros."]
[null,null,null,null,"Note: This calculator is for use with Excel for Mac 2011 and Excel 2007 or later."]
[]
[null,null,null,null,"Step 2. "]
[null,null,null,null,"Unit of measurement",null,null,null,null,null,"IP units"]
[null,null,null,null,"Note: This selection must match the unit of measurement chosen during project registration."]
[]
[null,null,null,null,"Step 3. "]
[null,null,null,null,"LEED rating system version",null,null,null,null,null,"LEED v4.1"]
[null,null,null,null,"Note: This selection must match project registration."]
[]
[null,null,null,null,"Step 4. "]
[null,null,null,null,"Increase breathing zone outdoor airflow by 30%?",null,null,null,null,null,"Yes"]
[null,null,null,null,{"$f":"IF(LEED=1,\"Select if attempting EQ Credit Increased Ventilation.\",\"Select if attempting EQ Credit Enhanced Indoor Air Quality Strategies, Option 2, Strategy B: Increased Ventilation.\")","v":"Select if attempting EQ Credit Enhanced Indoor Air Quality Strategies, Option 2, Strategy B: Increased Ventilation."}]
[]
[null,null,null,null,"Increase breathing zone outdoor airflow?",null,null,null,null,null,"No"]
[null,null,null,null,"Select if attempting EQ Credit Enhanced Indoor Air Qualities Strategies: Strategy 5. Increased Ventilation 15% OR Strategy 6. Increased Ventilation 30%"]
[]
[null,null,null,null,"Step 5. "]
[null,null,null,null,"Single Zone Systems"]
[null,null,null,null,"Does the project include single zone systems?",null,null,null,null,null,"No"]
[]
[null,null,null,null,"Multiple Zone and 100% Outdoor Air Systems"]
[null,null,null,null,"Add a tab for each multiple zone and 100% outdoor air system in the project using the \"Add System\" button below."]
[]
[]
[null,null,null,null,"Step 6."]
[null,null,null,null,"Complete the ventilation rate procedure (VRP) for each ventilation system, at the specified analysis condition.  "]
[]
[null,null,null,null,"Step 7."]
[null,null,null,null,"Upload the completed spreadsheet to LEED Online.  Complete any related summary fields in the LEED credit form with the results of the calculator."]
[]
[]
[]
[null,null,"Assumptions"]
[null,null,"Zone Air Distribution Effectiveness (Ez)"]
[null,null,"Code",null,null,"Air Distribution Configuration",null,null,null,null,"Ez"]
[null,null,"CS",null,null,"Ceiling supply of cool air",null,null,null,null,1]
[null,null,"CSFR",null,null,"Ceiling supply of warm air and floor return",null,null,null,null,1]
[null,null,"CSCRH",null,null,"Ceiling supply of warm air 15°F (8°C) or more above space temperature and ceiling return",null,null,null,null,0.8]
[null,null,"CSCRW ",null,null,"Ceiling supply of warm air less than 15°F (8°C) above space temperature and ceiling return provided that the 150 fpm (0.8 m/s) supply air jet reaches to within 4.5 ft (1.4 m) of floor level. Note: For lower velocity supply air, Ez = 0.8.",null,null,null,null,1]
[null,null,"FSCR ",null,null,{"$f":"IF($K$14=\"LEED v4.1\",\"Floor supply of cool air and ceiling return, provided that the vertical throw is greater than 50 fpm (0.25 m/s) at a height of 4.5 ft (1.4 m) or more above the floor.\",\"Floor supply of cool air and ceiling return provided that the 150 fpm (0.8 m/s) supply jet reaches 4.5 ft (1.4 m) or more above the floor. Note: Most underfloor air distribution systems comply with this provision.\")","v":"Floor supply of cool air and ceiling return, provided that the vertical throw is greater than 50 fpm (0.25 m/s) at a height of 4.5 ft (1.4 m) or more above the floor."},null,null,null,null,1]
[null,null,"FSCR-LV",null,null,{"$f":"IF($K$14=\"LEED v4.1\",CONCATENATE(\"Floor supply of cool air and ceiling return, provided low-velocity displacement ventilation achieves unidirectional flow and thermal stratification, or underfloor air distribution systems where the vertical\",\"throw is less than or equal to 50 fpm (0.25 m/s) at a height of 4.5 ft (1.4 m) above the floor\"),\"Floor supply of cool air and ceiling return, provided low-velocity displacement ventilation achieves unidirectional flow and thermal stratification\")","v":"Floor supply of cool air and ceiling return, provided low-velocity displacement ventilation achieves unidirectional flow and thermal stratification, or underfloor air distribution systems where the verticalthrow is less than or equal to 50 fpm (0.25 m/s) at a height of 4.5 ft (1.4 m) above the floor"},null,null,null,null,1.2]
[null,null,"FSFR",null,null,"Floor supply of warm air and floor return",null,null,null,null,1]
[null,null,"FSCRW",null,null,"Floor supply of warm air and ceiling return",null,null,null,null,0.7]
[null,null,"MUEX",null,null,{"$f":"IF($K$14=\"LEED v4.1\",\"Makeup supply drawn in on the opposite side of the room from the exhaust, return, or both.\",\"Makeup supply drawn in on the opposite side of the room from the exhaust and/or return\")","v":"Makeup supply drawn in on the opposite side of the room from the exhaust, return, or both."},null,null,null,null,0.8]
[null,null,"MU-EX",null,null,{"$f":"IF($K$14=\"LEED v4.1\",\"Makeup supply drawn in near to the exhaust, return, or both locations.\",\"Makeup supply drawn in near to the exhaust and/or return location.\")","v":"Makeup supply drawn in near to the exhaust, return, or both locations."},null,null,null,null,0.5]
[null,null,{"$f":"IF($K$14=\"LEED v4.1\",\"Source: ASHRAE 62.1-2016, Table 6.2.2.2\",\"Source: ASHRAE 62.1, Table 6-2\")","v":"Source: ASHRAE 62.1-2016, Table 6.2.2.2"}]
[]
[null,null,"System Ventilation Efficiency (Ev)"]
[null,null,{"$f":"IF($K$14=\"LEED v4.1\",\"Max Zpz\",\"Max Zp\")","v":"Max Zpz"},null,null,"Ev"]
[null,null,"<=0.15",null,null,1]
[null,null,"<=0.25",null,null,0.9]
[null,null,"<=0.35",null,null,0.8]
[null,null,"<=0.45",null,null,0.7]
[null,null,"<=0.55",null,null,0.6]
[null,null,">0.55",null,null,{"$f":"IF($K$14=\"LEED v4.1\",\"Use Normative Appendix A\",\"use Appendix A\")","v":"Use Normative Appendix A"}]
[null,null,{"$f":"IF($K$14=\"LEED v4.1\",\"Source: ASHRAE 62.1-2016, Table 6.2.2.2\",\"Source: ASHRAE 62.1, Table 6-3\")","v":"Source: ASHRAE 62.1-2016, Table 6.2.2.2"}]
[]
[null,null,"Zone Secondary Recirculation Fraction (Er)"]
[null,null,"System Configuration",null,null,null,null,null,null,null,"Er"]
[null,null,"Plenum return systems with secondary recirculation (e.g., fan-powered VAV with plenum return)",null,null,null,null,null,null,null,"<1.0"]
[null,null,"Ducted return systems with secondary recirculation (e.g., fan-powered VAV with ducted return)",null,null,null,null,null,null,null,0]
[null,null,"Systems with system-level recirculation (e.g., dual-fan dual-duct systems with ducted return)",null,null,null,null,null,null,null,1]
[null,null,"Other system types",null,null,null,null,null,null,null,0.75]
[null,null,"Source: ASHRAE 62.1, Section A1.2.2"]
[]
[null,null,"Occupancy"]
[null,null,"Occupancy \nCategory ",null,null,null,"People OA Rate",null,"Area OA Rate",null,"Default Occupant Density                 (#/1000 sq ft or #/100 sq m)",null,null,"9= 2009 only\n4=v4 only\nB= Both"]
[null,null,null,null,null,null,"(cfm per person)","(l/s per person)","(cfm per sq ft) ","(l/s per sq m)"]
[null,null,"Art classroom ",null,null,null,10,5,0.18,0.9,20,null,null,"B"]
[null,null,"Auditorium seating area ",null,null,null,5,2.5,0.06,0.3,150,null,null,"B"]
[null,null,"Bank vault / safe deposit ",null,null,null,5,2.5,0.06,0.3,5,null,null,"B"]
[null,null,"Banks or bank lobbies",null,null,null,7.5,3.8,0.06,0.3,15,null,null,4]
[null,null,{"$f":"IF($O$169=1,\"Barber shop\",\"Barbershop\")","v":"Barbershop"},null,null,null,7.5,3.8,0.06,0.3,25,null,null,"B"]
[null,null,"Barracks sleeping areas ",null,null,null,5,2.5,0.06,0.3,20,null,null,"B"]
[null,null,"Bars / cocktail lounges ",null,null,null,7.5,3.8,0.18,0.9,100,null,null,"B"]
[null,null,"Beauty and nail salon ",null,null,null,20,10,0.12,0.6,25,null,null,"B"]
[null,null,"Bedroom / living room ",null,null,null,5,2.5,0.06,0.3,10,null,null,"B"]
[null,null,"Booking / waiting ",null,null,null,7.5,3.8,0.06,0.3,50,null,null,"B"]
[null,null,"Bowling alley (seating)",null,null,null,10,5,0.12,0.6,40,null,null,"B"]
[null,null,"Break rooms (general)",null,null,null,5,2.5,0.06,0.3,25,null,null,"B"]
[null,null,"Breakrooms (office buildings)",null,null,null,5,2.5,0.12,0.6,50,null,null,4]
[null,null,"Cafeteria / fast food dining ",null,null,null,7.5,3.8,0.18,0.9,100,null,null,"B"]
[null,null,"Cell",null,null,null,5,2.5,0.12,0.6,25,null,null,"B"]
[null,null,"Classrooms (age 9 plus)",null,null,null,10,5,0.12,0.6,35,null,null,"B"]
[null,null,"Classrooms (ages 5-8)",null,null,null,10,5,0.12,0.6,25,null,null,"B"]
[null,null,"Coffee stations",null,null,null,5,2.5,0.06,0.3,20,null,null,"B"]
[null,null,"Coin-operated laundries ",null,null,null,7.5,3.8,{"$f":"IF($O$169=1,\"0.06\",\"0.12\")","v":"0.12"},{"$f":"IF($O$169=1,\"0.3\",\"0.6\")","v":"0.6"},20,null,null,"B"]
[null,null,"Common corridors",null,null,null,0,0,0.06,0.3,0,null,null,"B"]
[null,null,"Computer (not printing ) ",null,null,null,5,2.5,0.06,0.3,4,null,null,"B"]
[null,null,"Computer lab",null,null,null,10,5,0.12,0.6,25,null,null,"B"]
[null,null,"Conference / meeting ",null,null,null,5,2.5,0.06,0.3,50,null,null,"B"]
[null,null,"Corridors ",null,null,null,0,0,0.06,0.3,0,null,null,"B"]
[null,null,"Courtrooms ",null,null,null,5,2.5,0.06,0.3,70,null,null,"B"]
[null,null,"Day room ",null,null,null,5,2.5,0.06,0.3,30,null,null,"B"]
[null,null,"Daycare (through age 4)",null,null,null,10,5,0.18,0.9,25,null,null,"B"]
[null,null,"Daycare sickroom",null,null,null,10,5,0.18,0.9,25,null,null,"B"]
[null,null,"Disco / dance floors ",null,null,null,20,10,0.06,0.3,100,null,null,"B"]
[null,null,"Dwelling unit",null,null,null,5,2.5,0.06,0.3,"n/a",null,null,9]
[null,null,"Dwelling unit - studio or one-bedroom",null,null,null,5,2.5,0.06,0.3,2,null,null,4]
[null,null,"Dwelling unit - three-bedroom",null,null,null,5,2.5,0.06,0.3,4,null,null,4]
[null,null,"Dwelling unit - two-bedroom",null,null,null,5,2.5,0.06,0.3,3,null,null,4]
[null,null,"Electrical equipment rooms",null,null,null,0,0,0.06,0.3,0,null,null,9]
[null,null,"Elevator machine rooms",null,null,null,0,0,0.12,0.6,0,null,null,9]
[null,null,"Freezer and refrigerated spaces <50 deg F",null,null,null,10,5,0,0,0]
[null,null,"Gambling casinos ",null,null,null,7.5,3.8,0.18,0.9,120,null,null,"B"]
[null,null,"Game arcades ",null,null,null,7.5,3.8,0.18,0.9,20,null,null,"B"]
[null,null,"General manufacturing (excludes heavy \nindustrial and processes using chemicals)",null,null,null,10,5,0.18,0.9,7,null,null,4]
[null,null,"Guard stations",null,null,null,5,2.5,0.06,0.3,15,null,null,"B"]
[null,null,{"$f":"IF($K$14=\"LEED v4.1\",\"Gym, sports arena (play area)\",\"Gym, stadium (play area)\")","v":"Gym, sports arena (play area)"},null,null,null,{"$f":"IF($K$14=\"LEED v4.1\",\"20\",\"0\")","v":"20"},{"$f":"IF($K$14=\"LEED v4.1\",\"10\",\"0\")","v":"10"},{"$f":"IF($K$14=\"LEED v4.1\",\"0.18\",\"0.3\")","v":"0.18"},{"$f":"IF($K$14=\"LEED v4.1\",\"0.9\",\"1.5\")","v":"0.9"},{"$f":"IF($K$14=\"LEED v4.1\",\"7\",\"30\")","v":"7"},null,null,"B"]
[null,null,"Health club / aerobics",null,null,null,20,10,0.06,0.3,40,null,null,"B"]
[null,null,"Health club / weight",null,null,null,20,10,0.06,0.3,10,null,null,"B"]
[null,null,"Kitchen (cooking)",null,null,null,7.5,3.8,0.12,0.6,20,null,null,4]
[null,null,"Laundry rooms within dwelling units",null,null,null,5,2.5,0.12,0.6,10,null,null,"B"]
[null,null,"Laundry rooms, central",null,null,null,5,2.5,0.12,0.6,10,null,null,"B"]
[null,null,"Lecture classroom ",null,null,null,7.5,3.8,0.06,0.3,65,null,null,"B"]
[null,null,"Lecture hall (fixed seats)",null,null,null,7.5,3.8,0.06,0.3,150,null,null,"B"]
[null,null,"Legislative chambers ",null,null,null,5,2.5,0.06,0.3,50,null,null,"B"]
[null,null,"Libraries ",null,null,null,5,2.5,0.12,0.6,10,null,null,"B"]
[null,null,"Lobbies ",null,null,null,5,2.5,0.06,0.3,150,null,null,"B"]
[null,null,"Lobbies / prefunction ",null,null,null,7.5,3.8,0.06,0.3,30,null,null,"B"]
[null,null,"Main entry lobbies ",null,null,null,5,2.5,0.06,0.3,10,null,null,"B"]
[null,null,"Mall common areas ",null,null,null,7.5,3.8,0.06,0.3,40,null,null,"B"]
[null,null,"Media center ",null,null,null,10,5,0.12,0.6,25,null,null,"B"]
[null,null,"Multi-purpose assembly ",null,null,null,5,2.5,0.06,0.3,120,null,null,"B"]
[null,null,"Multi-use assembly ",null,null,null,7.5,3.8,0.06,0.3,100,null,null,"B"]
[null,null,"Museums (children's)",null,null,null,7.5,3.8,0.12,0.6,40,null,null,"B"]
[null,null,"Museums / galleries ",null,null,null,7.5,3.8,0.06,0.3,40,null,null,"B"]
[null,null,"Music / theater/ dance ",null,null,null,10,5,0.06,0.3,35,null,null,"B"]
[null,null,"Occupiable storage rooms for dry materials",null,null,null,5,2.5,0.06,0.3,2,null,null,4]
[null,null,"Occupiable storage rooms for liquids or gels",null,null,null,5,2.5,0.12,0.6,2,null,null,4]
[null,null,"Office space ",null,null,null,5,2.5,0.06,0.3,5,null,null,"B"]
[null,null,{"$f":"IF($O$169=1,\"Pet shops\",\"Pet shops (animal areas)\")","v":"Pet shops (animal areas)"},null,null,null,7.5,3.8,0.18,0.9,10,null,null,"B"]
[null,null,"Pharmacy (prep, area)",null,null,null,5,2.5,0.18,0.9,10,null,null,"B"]
[null,null,"Photo studios",null,null,null,5,2.5,0.12,0.6,10,null,null,"B"]
[null,null,"Places of religious worship",null,null,null,5,2.5,0.06,0.3,120,null,null,"B"]
[null,null,"Reception areas ",null,null,null,5,2.5,0.06,0.3,30,null,null,"B"]
[null,null,"Restaurant dining rooms ",null,null,null,7.5,3.8,0.18,0.9,70,null,null,"B"]
[null,null,"Sales ",null,null,null,7.5,3.8,0.12,0.6,15,null,null,"B"]
[null,null,"Science laboratories",null,null,null,10,5,0.18,0.9,25,null,null,"B"]
[null,null,"Shipping / receiving ",null,null,null,{"$f":"IF($O$169=1,0,10)","v":10},{"$f":"IF($O$169=1,0,5)","v":5},0.12,0.6,{"$f":"IF($O$169=1,\"0\",\"2\")","v":"2"},null,null,"B"]
[null,null,"Sorting, packing, light assembly",null,null,null,7.5,3.8,0.12,0.6,7,null,null,4]
[null,null,"Spectator areas ",null,null,null,7.5,3.8,0.06,0.3,150,null,null,"B"]
[null,null,"Sports arena (play area)",null,null,null,0,0,0.3,1.5,0,null,null,"B"]
[null,null,"Stages, studios ",null,null,null,10,5,0.06,0.3,70,null,null,"B"]
[null,null,"Storage rooms ",null,null,null,0,0,0.12,0.6,0,null,null,9]
[null,null,"Supermarket ",null,null,null,7.5,3.8,0.06,0.3,8,null,null,"B"]
[null,null,"Swimming (pool & deck)",null,null,null,0,0,0.48,2.4,0,null,null,"B"]
[null,null,"Telephone / data entry ",null,null,null,5,2.5,0.06,0.3,60,null,null,"B"]
[null,null,"Telephone closets",null,null,null,0,0,0,0,0,null,null,4]
[null,null,"Transportation waiting",null,null,null,7.5,3.8,0.06,0.3,100,null,null,"B"]
[null,null,"University / college laboratories",null,null,null,10,5,0.18,0.9,25,null,null,4]
[null,null,"Warehouses",null,null,null,{"$f":"IF($O$169=1,0,10)","v":10},{"$f":"IF($O$169=1,0,5)","v":5},0.06,0.3,0,null,null,"B"]
[null,null,"Wood / metal shop ",null,null,null,10,5,0.18,0.9,20,null,null,"B"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"v05"]
[null,null,null,null,null,null,null,null,null,null,null,"Copyright © 2019"]
[null,null,null,null,null,null,null,null,null,null,null,"U.S. Green Building Council"]
[null,null,null,null,null,null,null,null,null,null,null,"All Rights Reserved"]
[null,null,null,null,null,null,null,null,null,null,null,"Last updated 07/28/23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"UOM","LEED","Credit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K10=\"IP units\",1,2)","v":1},{"$f":"IF(K14=\"LEED 2009\",1,2)","v":2},{"$f":"IF(K18=\"Yes\",1,2)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1 = IP, 2 = SI","1 = 2009, 2 = v4","1 = yes, 2 = no"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"LEED2009","LEEDv4","Single Zone","LEEDv4.1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Art classroom ","Art classroom ",{"$f":"IF(K26=\"Yes\",1,2)","v":2},"Art classroom "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Auditorium seating area ","Auditorium seating area ","1 = yes, 2 = no","Auditorium seating area "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bank vault / safe deposit ","Bank vault / safe deposit ",null,"Bank vault / safe deposit "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Barber shop","Banks or bank lobbies",null,"Banks or bank lobbies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Barracks sleeping areas ","Barbershop",null,{"$f":"IF($O$169=1,\"Barber shop\",\"Barbershop\")","v":"Barbershop"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bars / cocktail lounges ","Barracks sleeping areas ",null,"Barracks sleeping areas "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Beauty and nail salon ","Bars / cocktail lounges ",null,"Bars / cocktail lounges "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bedroom / living room ","Beauty and nail salon ",null,"Beauty and nail salon "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Booking / waiting ","Bedroom / living room ",null,"Bedroom / living room "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bowling alley (seating)","Booking / waiting ",null,"Booking / waiting "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Break rooms (general)","Bowling alley (seating)",null,"Bowling alley (seating)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cafeteria / fast food dining ","Break rooms (general)",null,"Break rooms (general)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cell","Breakrooms (office buildings)",null,"Breakrooms (office buildings)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Classrooms (age 9 plus)","Cafeteria / fast food dining ",null,"Cafeteria / fast food dining "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Classrooms (ages 5-8)","Cell",null,"Cell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Coffee stations","Classrooms (age 9 plus)",null,"Classrooms (age 9 plus)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Coin-operated laundries ","Classrooms (ages 5-8)",null,"Classrooms (ages 5-8)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Common corridors","Coffee stations",null,"Coffee stations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Computer (not printing ) ","Coin-operated laundries ",null,"Coin-operated laundries "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Computer lab","Common corridors",null,"Common corridors"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Conference / meeting ","Computer (not printing ) ",null,"Computer (not printing ) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Corridors ","Computer lab",null,"Computer lab"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Courtrooms ","Conference / meeting ",null,"Conference / meeting "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Day room ","Corridors ",null,"Corridors "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Daycare (through age 4)","Courtrooms ",null,"Courtrooms "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Daycare sickroom","Day room ",null,"Day room "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Disco / dance floors ","Daycare (through age 4)",null,"Daycare (through age 4)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Dwelling unit","Disco / dance floors ",null,"Daycare sickroom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical equipment rooms","Dwelling unit - studio or one-bedroom",null,"Disco / dance floors "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Elevator machine rooms","Dwelling unit - three-bedroom",null,"Dwelling unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gambling casinos ","Dwelling unit - two-bedroom",null,"Dwelling unit - studio or one-bedroom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Game arcades ","Gambling casinos ",null,"Dwelling unit - three-bedroom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Guard stations","Game arcades ",null,"Dwelling unit - two-bedroom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gym, stadium (play area)","General manufacturing (excludes heavy \nindustrial and processes using chemicals)",null,"Electrical equipment rooms"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Health club / aerobics","Guard stations",null,"Elevator machine rooms"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Health club / weight","Gym, stadium (play area)",null,"Freezer and refrigerated spaces <50 deg F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Laundry rooms within dwelling units","Health club / aerobics",null,"Gambling casinos "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Laundry rooms, central","Health club / weight",null,"Game arcades "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lecture classroom ","Kitchen (cooking)",null,"General manufacturing (excludes heavy \nindustrial and processes using chemicals)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lecture hall (fixed seats)","Laundry rooms within dwelling units",null,"Guard stations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Legislative chambers ","Laundry rooms, central",null,{"$f":"IF($K$14=\"LEED v4.1\",\"Gym, sports arena (play area)\",\"Gym, stadium (play area)\")","v":"Gym, sports arena (play area)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Libraries ","Lecture classroom ",null,"Health club / aerobics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lobbies ","Lecture hall (fixed seats)",null,"Health club / weight"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lobbies / prefunction ","Legislative chambers ",null,"Kitchen (cooking)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Main entry lobbies ","Libraries ",null,"Laundry rooms within dwelling units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mall common areas ","Lobbies ",null,"Laundry rooms, central"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Media center ","Lobbies / prefunction ",null,"Lecture classroom "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Multi-purpose assembly ","Main entry lobbies ",null,"Lecture hall (fixed seats)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Multi-use assembly ","Mall common areas ",null,"Legislative chambers "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Museums (children's)","Media center ",null,"Libraries "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Museums / galleries ","Multi-purpose assembly ",null,"Lobbies "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Music / theater/ dance ","Multi-use assembly ",null,"Lobbies / prefunction "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Office space ","Museums (children's)",null,"Main entry lobbies "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pet shops","Museums / galleries ",null,"Mall common areas "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pharmacy (prep, area)","Music / theater/ dance ",null,"Media center "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Photo studios","Occupiable storage rooms for dry materials",null,"Multi-purpose assembly "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Places of religious worship","Occupiable storage rooms for liquids or gels",null,"Multi-use assembly "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Reception areas ","Office space ",null,"Museums (children's)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Restaurant dining rooms ","Pet shops (animal areas)",null,"Museums / galleries "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales ","Pharmacy (prep, area)",null,"Music / theater/ dance "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Science laboratories","Photo studios",null,"Occupiable storage rooms for dry materials"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Shipping / receiving ","Places of religious worship",null,"Occupiable storage rooms for liquids or gels"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Spectator areas ","Reception areas ",null,"Office space "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sports arena (play area)","Restaurant dining rooms ",null,{"$f":"IF($O$169=1,\"Pet shops\",\"Pet shops (animal areas)\")","v":"Pet shops (animal areas)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Stages, studios ","Sales ",null,"Pharmacy (prep, area)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Storage rooms ","Science laboratories",null,"Photo studios"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Supermarket ","Shipping / receiving ",null,"Places of religious worship"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Swimming (pool & deck)","Sorting, packing, light assembly",null,"Reception areas "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephone / data entry ","Spectator areas ",null,"Restaurant dining rooms "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Transportation waiting","Sports arena (play area)",null,"Sales "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Warehouses","Stages, studios ",null,"Science laboratories"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood / metal shop ","Supermarket ",null,"Shipping / receiving "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swimming (pool & deck)",null,"Sorting, packing, light assembly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephone / data entry ",null,"Spectator areas "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephone closets",null,"Stages, studios "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transportation waiting",null,"Storage rooms "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"University / college laboratories",null,"Supermarket "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warehouses",null,"Swimming (pool & deck)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood / metal shop ",null,"Telephone / data entry "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephone closets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"max Zpz","Ev",null,"Transportation waiting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,null,"University / college laboratories"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.01,1,null,"Warehouses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.02,1,null,"Wood / metal shop "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.04,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.06,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.08,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.09,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.11,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.12,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.13,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.14000000000000001,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.16,0.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.17,0.98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.18,0.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.19,0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.21,0.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.22,0.92999999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.23,0.91999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.24,0.90999999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,0.89999999999999991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.26,0.8899999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.27,0.87999999999999989]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.28000000000000003,0.86999999999999988]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.28999999999999998,0.85999999999999988]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,0.84999999999999987]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.31,0.83999999999999986]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.32,0.82999999999999985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.33,0.81999999999999984]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.34,0.80999999999999983]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,0.79999999999999982]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.36,0.78999999999999981]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.37,0.7799999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.38,0.7699999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.39,0.75999999999999979]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.74999999999999978]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.41,0.73999999999999977]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.42,0.72999999999999976]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.43,0.71999999999999975]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.44,0.70999999999999974]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,0.69999999999999973]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.46,0.68999999999999972]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.47,0.67999999999999972]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.48,0.66999999999999971]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.49,0.6599999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0.64999999999999969]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.51,0.63999999999999968]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.52,0.62999999999999967]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.53,0.61999999999999966]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.54,0.60999999999999965]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004,0.59999999999999964]

{"sheet":"Multiple Zone","index":1,"n_rows":37,"n_cols":36,"rows_kept":37,"cut":false,"hidden":true,"merged":[[9,10,10,10],[9,1,11,1],[9,2,11,3],[9,5,11,5],[15,2,15,3],[9,9,10,9],[13,2,13,3],[28,1,28,3],[5,1,5,2],[6,1,6,2],[12,2,12,3],[14,2,14,3],[7,1,7,2]]}
[]
[null,"Multiple zone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor area","Population","Rp","Ra","D","Ez average","Ev","Vps","Xs","Required Vot","Actual"]
[null,{"$f":"REPLACE(CELL(\"filename\",A1),1,FIND(\"]\",CELL(\"filename\",A1)),\"\")","v":"Multiple Zone"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Area","v":0},{"$f":"$E$20","v":0},{"$f":"IFERROR(IF(Allzones=\"Yes\",(SUM($J14:$J16)/SUM($G14:$G16)),$E$23),0)","v":0},{"$f":"IFERROR(IF(Allzones=\"Yes\",(SUM($K14:$K16)/Area),$E$24),0)","v":0},{"$f":"$E$22","v":0},{"$f":"IFERROR(AVERAGEIF($M$14:$M$16,\"<>0\"),0)","v":0},{"$f":"Ev","v":0},{"$f":"Airflow_cz","v":0},{"$f":"$E$27","v":0},{"$f":"ROUND(E35,0)","v":0},{"$f":"ROUND(E37,0)","v":0}]
[]
[null,"Show simple view",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,"System name and number",null,{"$f":"B3","v":"Multiple Zone"}]
[null,"Condition analyzed (impacts Ez, Vdz, Vpz and Vps)"]
[null,"All zones are included in the VRP calculation"]
[]
[null,"Zone Name \nand Number","Occupancy \nCategory",null,"Zone \nFloor Area","Are you using default value for zone population?","Zone \nPopulation","People \nOutdoor \nAir Rate ","Area\nOutdoor\nAir Rate","Breathing \nZone Outdoor Airflow\n(people related portion)","Breathing\nZone Outdoor\nAirflow\n(area related portion)","Breathing \nZone Outdoor Airflow","Zone Air Distribution Effectiveness","Zone \nOutdoor \nAirflow","Zone \nDischarge Airflow","Zone \nPrimary \nAirflow","Primary Outdoor Air Fraction","Zone Secondary Recirculation Fraction","Zone Primary Air Fraction","Supply Air Fraction","Mixed Air Fraction","Outdoor Air Fraction","Zone Ventilation Efficiency (Appendix A)",null,"Default Pz","Nondefault\nPz","Occupant Density","Zone name for critical zone lookup"]
[null,null,null,null,"Az",null,"Pz","Rp","Ra",null,null,"Vbz","Ez","Voz","Vdz","Vpz","Zpz","Er","Ep","Fa","Fb","Fc","Evz"]
[null,null,null,null,{"$f":"IF(Instructions!$N$169=1,\"(sq ft)\",\"(sq m)\")","v":"(sq ft)"},null,"(people)",{"$f":"IF(Instructions!$N$169=1,Instructions!$G$75,Instructions!$H$75)","v":"(cfm per person)"},{"$f":"IF(Instructions!$N$169=1,Instructions!$I$75,Instructions!$J$75)","v":"(cfm per sq ft) "},{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},null,{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!$N$169=1,\"(occupants per 1,000 sq ft)\",\"(occupants per 100 sq m)\")","v":"(occupants per 1,000 sq ft)"}]
["A",null,null,null,null,null,null,null,null,"Rp Pz","Ra Az",{"$f":"IF(I_15,\"(Rp Pz + Ra Az)*1.15\",IF(I_30,\"(Rp Pz + Ra Az)*1.3\",IF(I_No,\"(Rp Pz + Ra Az)\",IF(AND(Instructions!K14<>\"LEED v4.1\",credit=1),\"(Rp Pz + Ra Az)*1.3\",\"(Rp Pz + Ra Az)\"))))","v":"(Rp Pz + Ra Az)"},null,"Vbz / Ez",null,null,"Voz / Vpz",null,"Vpz/Vdz","Ep + (1-Ep) Er","Ep","1-(1-Ez)(1-Er)(1-Ep)","(Fa+Xs * Fb-Zpz *Ep*Fc)/Fa"]
[{"$f":"IF(C14=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C14,Instructions!$C$76:$K$160,5,FALSE),VLOOKUP(C14,Instructions!$C$76:$K$160,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C14,Instructions!$C$76:$K$160,7,FALSE),VLOOKUP(C14,Instructions!$C$76:$K$160,8,FALSE)),0)","v":0},{"$f":"TRUNC(IFERROR(H14*G14,0),2)","v":0},{"$f":"TRUNC(IFERROR(I14*E14,0),2)","v":0},{"$f":"TRUNC(IFERROR(IF(I_15,SUM(J14:K14)*1.15,IF(I_30,SUM(J14:K14)*1.3,IF(I_No,SUM(J14:K14),IF(AND(Instructions!K14<>\"LEED v4.1\",credit=1),SUM(J14:K14)*1.3,SUM(J14:K14))))),0),2)","v":0},null,{"$f":"IFERROR(L14/M14,0)","v":0},null,null,{"$f":"IFERROR(ROUND(N14/P14,2),0)","v":0},null,{"$f":"IFERROR($P14/$O14,0)","v":0},{"$f":"TRUNC(IFERROR(S14+(1-S14)*R14,0),2)","v":0},{"$f":"TRUNC(S14,2)","v":0},{"$f":"TRUNC(IFERROR(1-(1-M14)*(1-R14)*(1-S14),0),2)","v":0},{"$f":"TRUNC(IFERROR(IF($E$27>0,(T14+$E$27 * U14-Q14 * S14 * V14)/T14,0),0),2)","v":0},null,{"$f":"IFERROR(IF(Instructions!$N$169=1,($AA14/1000)*$E14,($AA14/100)*$E14),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C14,Instructions!$C$76:$K$160,9,FALSE),0)","v":0},{"$f":"B14","v":0}]
[{"$f":"IF(C15=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C15,Instructions!$C$76:$K$160,5,FALSE),VLOOKUP(C15,Instructions!$C$76:$K$160,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C15,Instructions!$C$76:$K$160,7,FALSE),VLOOKUP(C15,Instructions!$C$76:$K$160,8,FALSE)),0)","v":0},{"$f":"TRUNC(IFERROR(H15*G15,0),2)","v":0},{"$f":"TRUNC(IFERROR(I15*E15,0),2)","v":0},{"$f":"TRUNC(IFERROR(IF(I_15,SUM(J15:K15)*1.15,IF(I_30,SUM(J15:K15)*1.3,IF(I_No,SUM(J15:K15),IF(AND(I_v4.1,credit=1),SUM(J15:K15)*1.3,SUM(J15:K15))))),0),2)","v":0},null,0,null,null,{"$f":"IFERROR(ROUND(N15/P15,2),0)","v":0},null,{"$f":"IFERROR($P15/$O15,0)","v":0},{"$f":"TRUNC(IFERROR(S15+(1-S15)*R15,0),2)","v":0},{"$f":"TRUNC(S15,2)","v":0},{"$f":"TRUNC(IFERROR(1-(1-M15)*(1-R15)*(1-S15),0),2)","v":0},{"$f":"TRUNC(IFERROR(IF($E$27>0,(T15+$E$27 * U15-Q15 * S15 * V15)/T15,0),0),2)","v":0},null,{"$f":"IFERROR(IF(Instructions!$N$169=1,($AA15/1000)*$E15,($AA15/100)*$E15),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C15,Instructions!$C$76:$K$160,9,FALSE),0)","v":0},{"$f":"B15","v":0}]
[0,null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C16,Instructions!$C$76:$K$160,5,FALSE),VLOOKUP(C16,Instructions!$C$76:$K$160,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C16,Instructions!$C$76:$K$160,7,FALSE),VLOOKUP(C16,Instructions!$C$76:$K$160,8,FALSE)),0)","v":0},{"$f":"TRUNC(IFERROR(H16*G16,0),2)","v":0},{"$f":"TRUNC(IFERROR(I16*E16,0),2)","v":0},{"$f":"TRUNC(IFERROR(IF(I_15,SUM(J16:K16)*1.15,IF(I_30,SUM(J16:K16)*1.3,IF(I_No,SUM(J16:K16),IF(AND(I_v4.1,credit=1),SUM(J16:K16)*1.3,SUM(J16:K16))))),0),2)","v":0},null,{"$f":"IFERROR(L16/M16,0)","v":0},null,null,0,null,{"$f":"IFERROR($P16/$O16,0)","v":0},{"$f":"TRUNC(IFERROR(S16+(1-S16)*R16,0),2)","v":0},{"$f":"TRUNC(S16,2)","v":0},{"$f":"TRUNC(IFERROR(1-(1-M16)*(1-R16)*(1-S16),0),2)","v":0},{"$f":"TRUNC(IFERROR(IF($E$27>0,(T16+$E$27 * U16-Q16 * S16 * V16)/T16,0),0),2)","v":0},null,{"$f":"IFERROR(IF(Instructions!$N$169=1,($AA16/1000)*$E16,($AA16/100)*$E16),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C16,Instructions!$C$76:$K$160,9,FALSE),0)","v":0},{"$f":"B16","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"all zones","critical zones"]
[null,"System area","As",{"$f":"IF(Instructions!$N$169=1,\"(sq ft)\",\"(sq m)\")","v":"(sq ft)"},{"$f":"TRUNC(SUM($E14:$E16),2)","v":0},{"$f":"IF(D8=\"Yes\",\"Net occupiable floor area served by the ventilation system\", \"∑Az\")","v":"∑Az"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($E14:$E16)","v":0}]
[null,"System population","Ps","(people)"]
[null,"Sum of zone population","sum of Pz","(people)",{"$f":"TRUNC(SUM(G14:G16),2)","v":0},"∑Pz"]
[null,"Occupant diversity","D",null,{"$f":"TRUNC(IFERROR(E20/E21,0),2)","v":0},"Ps / ∑Pz"]
[null,"People outdoor air rate for system","Rp system",{"$f":"IF(Instructions!$N$169=1,Instructions!$G$75,Instructions!$H$75)","v":"(cfm per person)"}]
[null,"Area outdoor air rate for system","Ra system",{"$f":"IF(Instructions!$N$169=1,Instructions!$I$75,Instructions!$J$75)","v":"(cfm per sq ft) "}]
[null,"Uncorrected outdoor air intake","Vou",{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"TRUNC(IF(ISBLANK($E$20),0,IF(D8=\"No\", IF(I_15,( E23*E20+E24*E19)*1.15, IF(I_30, ( E23*E20+E24*E19)*1.3, IF(I_No, (E23*E20+E24*E19), IF(AND(I_v4.1,credit=1),(E23*E20+E24*E19)*1.3, IF(AND(I_v4.1,credit=2),(E23*E20+E24*E19)))))), IF(I_15,(E22*SUM(J14:J16)+SUM(K14:K16))*1.15, IF(I_30, (E22*SUM(J14:J16)+SUM(K14:K16))*1.3, IF(I_No, (E22*SUM(J14:J16)+SUM(K14:K16)), IF(AND(I_v4.1,credit=1),(E22*SUM(J14:J16)+SUM(K14:K16))*1.3, IF(AND(I_v4.1,credit=2),(E22*SUM(J14:J16)+SUM(K14:K16))))))))),2)","v":0},{"$f":"IF(D8=\"No\", IF(I_15,\"(Rp system Ps) + (Ra system As)*1.15\", IF(I_30,\" (Rp system Ps) + (Ra system As)*1.3\", IF(I_No, \"(Rp system Ps) + (Ra system As)\", IF(AND(I_v4.1,credit=1),\"(Rp system Ps) + (Ra system As)*1.3\", IF(AND(I_v4.1,credit=2),\"(Rp system Ps) + (Ra system As)\"))))), IF(I_15,\"D ∑ (Rp Pz) + ∑(Ra Az)*1.15\", IF(I_30, \"D ∑ (Rp Pz) + ∑(Ra Az)*1.3\", IF(I_No, \"D ∑ (Rp Pz) + ∑(Ra Az)\", IF(AND(I_v4.1,credit=1),\"D ∑ (Rp Pz) + ∑(Ra Az)*1.3\", IF(AND(I_v4.1,credit=2),\"D ∑ (Rp Pz) + ∑(Ra Az)\"))))))","v":"D ∑ (Rp Pz) + ∑(Ra Az)"}]
[null,"System primary airflow (at condition analyzed)","Vps",{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"}]
[null,"Average outdoor air fraction","Xs",null,{"$f":"TRUNC(IFERROR(E25/Airflow_cz,0),2)","v":0},"Vou / Vps"]
[null,""]
[null,"Which method from ASHRAE 62.1 is being used to determine system ventilation efficiency (Ev)?"]
[null,"Max (Zpz)","Max Zpz",null,{"$f":"MAX($Q$14:$Q$16)","v":0}]
[null,"Zone ventilation efficiency (Table 6-3)","Evz",null,{"$f":"IF(E30>0,IF(E30=0,1.15,IF(E30>0.55,\"Use Appendix A\",VLOOKUP(E30,Instructions!$N$255:$O$309,2,TRUE))),0)","v":0}]
[null,"Minimum (Evz)",null,null,{"$f":"MIN(IF($C$14:$D$16>0,$W$14:$W$16))","v":0}]
[null,"Critical zone",null,null,{"$f":"VLOOKUP(E30,Q14:AB16,12,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not other","Other"]
[null,"Ventilation efficiency","Ev",null,null,{"$f":"IF(AND(E29<>\"Table 6-3\",E29<>\"Appendix A\"),\" \", \"Ventilation efficiency from critical zone\")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E29=\"Table 6-3\",$E31,$E32)","v":0}]
[null,{"$f":"IF(I_15,\"Outdoor air intake flow (15% above 62.1 requirement)\",IF(I_30,\"Outdoor air intake flow (30% above 62.1 requirement)\",IF(I_No,\"Outdoor air intake flow (required by 62.1)\",IF(AND(Instructions!K14<>\"LEED v4.1\",credit=1),\"Outdoor air intake flow (30% above 62.1 requirement)\",\"Outdoor air intake flow (required by 62.1)\"))))","v":"Outdoor air intake flow (required by 62.1)"},"Vot",{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IFERROR(E25/E34,0)","v":0},"Vou / Ev"]
[]
[null,"Outdoor air intake flow provided (measured or design)",null,{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"}]

{"sheet":"100% OA","index":2,"n_rows":23,"n_cols":41,"rows_kept":23,"cut":false,"hidden":true,"merged":[[12,2,12,3],[8,1,10,1],[8,5,10,5],[15,2,15,3],[14,2,14,3],[13,2,13,3],[8,9,9,9],[8,10,9,10],[8,15,11,15],[8,17,10,17],[8,2,10,3],[11,2,11,3],[8,16,11,16]]}
[]
[null,"100% Outdoor air",null,null,null,null,null,null,null,null,null,null,null,null,null,">>>>",">>>>",">>>>",">>>>",">>>>",">>>>",">>>>",">>>>",">>>>",">>>>","Floor area","Population","Rp","Ra","D","Ez average","Ev","Vps","Xs","Required Vot","Actual"]
[null,{"$f":"REPLACE(CELL(\"filename\",A1),1,FIND(\"]\",CELL(\"filename\",A1)),\"\")","v":"100% OA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$19","v":0},{"$f":"$E$20","v":0},{"$f":"IFERROR(SUM($J$13:$J$16)/$E$20,0)","v":0},{"$f":"IFERROR(SUM($K$13:$K$16)/$E$19,0)","v":0},"n/a",{"$f":"IFERROR(AVERAGEIF($M$13:$M$16,\"<>0\"),0)","v":0},"n/a","n/a","n/a",{"$f":"ROUND($E$21,0)","v":0},{"$f":"ROUND($E$23,0)","v":0}]
[]
[null,"Show simple view",null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,"System name and number",null,{"$f":"B3","v":"100% OA"}]
[null,"Condition analyzed (impacts Ez)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($AL13:$AL16,\"No\")","v":0},{"$f":"SUM(AM7-0)","v":0},{"$f":"IF(AN7=0,\"Yes\",\"No\")","v":"Yes"}]
[]
[null,"Zone Name \nand Number","Occupancy\nCategory",null,"Zone \nFloor Area","Are you using default value for zone population?","Zone\nPopulation","People\nOutdoor \nAir Rate","Area\nOutdoor \nAir Rate","Breathing \nZone Outdoor Airflow\n(people related portion)","Breathing\nZone Outdoor\nAirflow\n(area related portion)","Breathing \nZone Outdoor Airflow","Zone Air Distribution Effectiveness","Zone \nOutdoor \nAirflow","Zone \nOutdoor \nAirflow Provided","Default Pz","Default Pz","Occupant Density"]
[null,null,null,null,"Az",null,"Pz","Rp","Ra",null,null,"Vbz","Ez","Voz","(measured or design)"]
["B",null,null,null,{"$f":"IF(Instructions!$N$169=1,\"(sq ft)\",\"(sq m)\")","v":"(sq ft)"},null,"(people)",{"$f":"IF(Instructions!$N$169=1,Instructions!$G$75,Instructions!$H$75)","v":"(cfm per person)"},{"$f":"IF(Instructions!$N$169=1,Instructions!$I$75,Instructions!$J$75)","v":"(cfm per sq ft) "},{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},null,{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"()\")","v":"(cfm)"}]
["A",null,null,null,null,null,null,null,null,"Rp Pz","Ra Az",{"$f":"IF(I_15,\"(Rp Pz + Ra Az)*1.15\",IF(I_30,\"(Rp Pz + Ra Az)*1.3\",IF(I_No,\"(Rp Pz + Ra Az)\",IF(AND(Instructions!K14<>\"LEED v4.1\",credit=1),\"(Rp Pz + Ra Az)*1.3\",\"(Rp Pz + Ra Az)\"))))","v":"(Rp Pz + Ra Az)"},null,"Vbz / Ez",null,null,null,{"$f":"IF(Instructions!N169=1,\"(occupants per 1,000 sq ft)\",\"(occupants per 100 sq m)\")","v":"(occupants per 1,000 sq ft)"}]
[{"$f":"IF(C13=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C13,Instructions!$C$76:$K$160,5,FALSE),VLOOKUP(C13,Instructions!$C$76:$K$160,6,FALSE)),0)","v":0},{"$f":"TRUNC(IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C13,Instructions!$C$76:$K$160,7,FALSE),VLOOKUP(C13,Instructions!$C$76:$K$160,8,FALSE)),0),2)","v":0},{"$f":"TRUNC(H13*G13,2)","v":0},{"$f":"TRUNC(I13*E13,2)","v":0},{"$f":"TRUNC(IF(I_15,(J13+K13)*1.15,IF(I_30,(J13+K13)*1.3,IF(I_No,(J13+K13),IF(AND(I_v4.1,credit=1),(J13+K13)*1.3,(J13+K13))))),2)","v":0},null,{"$f":"TRUNC(IFERROR(L13/M13,0),2)","v":0},null,{"$f":"IFERROR(IF(Instructions!$N$169=1,($R13/1000)*$E13,($R13/100)*$E13),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C13,Instructions!$C$76:$K$160,9,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($O13 >=$N13,\"Yes\",\"No\")","v":"Yes"}]
[{"$f":"IF(C14=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C14,Instructions!$C$76:$K$160,5,FALSE),VLOOKUP(C14,Instructions!$C$76:$K$160,6,FALSE)),0)","v":0},{"$f":"TRUNC(IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C14,Instructions!$C$76:$K$160,7,FALSE),VLOOKUP(C14,Instructions!$C$76:$K$160,8,FALSE)),0),2)","v":0},{"$f":"TRUNC(H14*G14,2)","v":0},{"$f":"TRUNC(I14*E14,2)","v":0},{"$f":"TRUNC(IF(I_15,(J14+K14)*1.15,IF(I_30,(J14+K14)*1.3,IF(I_No,(J14+K14),IF(AND(I_v4.1,credit=1),(J14+K14)*1.3,(J14+K14))))),2)","v":0},null,{"$f":"TRUNC(IFERROR(L14/M14,0),2)","v":0},null,{"$f":"IFERROR(IF(Instructions!$N$169=1,($R14/1000)*$E14,($R14/100)*$E14),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C14,Instructions!$C$76:$K$160,9,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($O14 >=$N14,\"Yes\",\"No\")","v":"Yes"}]
[{"$f":"IF(C15=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C15,Instructions!$C$76:$K$160,5,FALSE),VLOOKUP(C15,Instructions!$C$76:$K$160,6,FALSE)),0)","v":0},{"$f":"TRUNC(IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C15,Instructions!$C$76:$K$160,7,FALSE),VLOOKUP(C15,Instructions!$C$76:$K$160,8,FALSE)),0),2)","v":0},{"$f":"TRUNC(H15*G15,2)","v":0},{"$f":"TRUNC(I15*E15,2)","v":0},{"$f":"TRUNC(IF(I_15,(J15+K15)*1.15,IF(I_30,(J15+K15)*1.3,IF(I_No,(J15+K15),IF(AND(I_v4.1,credit=1),(J15+K15)*1.3,(J15+K15))))),2)","v":0},null,{"$f":"TRUNC(IFERROR(L15/M15,0),2)","v":0},null,{"$f":"IFERROR(IF(Instructions!$N$169=1,($R15/1000)*$E15,($R15/100)*$E15),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C15,Instructions!$C$76:$K$160,9,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($O15 >=$N15,\"Yes\",\"No\")","v":"Yes"}]
[0,null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C16,Instructions!$C$76:$K$160,5,FALSE),VLOOKUP(C16,Instructions!$C$76:$K$160,6,FALSE)),0)","v":0},{"$f":"TRUNC(IFERROR(IF(Instructions!$N$169=1,VLOOKUP(C16,Instructions!$C$76:$K$160,7,FALSE),VLOOKUP(C16,Instructions!$C$76:$K$160,8,FALSE)),0),2)","v":0},{"$f":"TRUNC(H16*G16,2)","v":0},{"$f":"TRUNC(I16*E16,2)","v":0},{"$f":"TRUNC(IF(I_15,(J16+K16)*1.15,IF(I_30,(J16+K16)*1.3,IF(I_No,(J16+K16),IF(AND(I_v4.1,credit=1),(J16+K16)*1.3,(J16+K16))))),2)","v":0},null,{"$f":"TRUNC(IFERROR(L16/M16,0),2)","v":0},null,{"$f":"IFERROR(IF(Instructions!$N$169=1,($R16/1000)*$E16,($R16/100)*$E16),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C16,Instructions!$C$76:$K$160,9,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($O16 >=$N16,\"Yes\",\"No\")","v":"Yes"}]
[]
[]
[null,{"$f":"CONCATENATE(\"System area \",IF(Instructions!$N$169=1,\"(sq ft)\",\"(sq m)\"))","v":"System area (sq ft)"},"As",{"$f":"IF(Instructions!$N$169=1,\"(sq ft)\",\"(sq m)\")","v":"(sq ft)"},{"$f":"TRUNC(SUM(E13:E16),2)","v":0},"∑Az"]
[null,"System population","Ps","(people)",{"$f":"TRUNC(SUM(G13:G16),2)","v":0},"∑Pz"]
[null,{"$f":"IF(I_15,\"Outdoor air intake flow (15% above 62.1 requirement)\",IF(I_30,\"Outdoor air intake flow (30% above 62.1 requirement)\",IF(I_No,\"Outdoor air intake flow (required by 62.1)\",IF(AND(Instructions!K14<>\"LEED v4.1\",credit=1),\"Outdoor air intake flow (30% above 62.1 requirement)\",\"Outdoor air intake flow (required by 62.1)\"))))","v":"Outdoor air intake flow (required by 62.1)"},"Vot",{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"TRUNC(SUM(N13:N16),0)","v":0},"∑Voz"]
[null,""]
[null,"Outdoor air intake flow provided (measured or design)",null,{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"}]

{"sheet":"Single Zone","index":3,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":true,"merged":[[6,14,9,14],[6,16,7,16],[8,16,9,16],[6,1,8,1],[6,2,8,2],[6,3,8,3],[6,12,7,12],[6,5,8,5],[6,15,9,15]]}
[]
[null,"Single zone"]
[null,"Single Zone"]
[]
[null,"Show simple view",null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,"System Name \nand Number","Condition\nAnalyzed (impacts Ez)","Occupancy \nCategory ","Zone \nFloor Area","Are you using default value for zone population?","Zone \nPopulation","People \nOutdoor \nAir Rate","Area\nOutdoor\nAir Rate","Breathing \nZone Outdoor Airflow","Zone Air Distribution Effectiveness","Zone \nOutdoor \nAirflow","Outdoor air intake flow provided (measured or design)",null,"Default Pz","Nondefault\nPz","Occupant Density"]
[null,null,null,null,"Az",null,"Pz","Rp","Ra","Vbz","Ez","Voz"]
["B",null,null,null,{"$f":"IF(Instructions!$N$169=1,\"(sq ft)\",\"(sq m)\")","v":"(sq ft)"},null,"people",{"$f":"IF(Instructions!$N$169=1,Instructions!$G$75,Instructions!$H$75)","v":"(cfm per person)"},{"$f":"IF(Instructions!$N$169=1,Instructions!$I$75,Instructions!$J$75)","v":"(cfm per sq ft) "},{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},null,{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},null,null,null,{"$f":"IF(Instructions!N169=1,\"Occupants \nper \n1,000 sq ft\",\"Occupants \nper \n100 sq m\")","v":"Occupants \nper \n1,000 sq ft"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I_15,\"(Rp Pz + Ra Az)*1.15\",IF(I_30,\"(Rp Pz + Ra Az)*1.3\",IF(I_No,\"(Rp Pz + Ra Az)\",IF(AND(Instructions!K14<>\"LEED v4.1\",credit=1),\"(Rp Pz + Ra Az)*1.3\",\"(Rp Pz + Ra Az)\"))))","v":"(Rp Pz + Ra Az)"},null,"Vbz / Ez"]
[null,"HIDDEN SPACER FOR SUMMARY"]
[{"$f":"IF(B12=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(D12,Instructions!$C$76:$K$160,5,FALSE),VLOOKUP(D12,Instructions!$C$76:$K$160,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(D12,Instructions!$C$76:$K$160,7,FALSE),VLOOKUP(D12,Instructions!$C$76:$K$160,8,FALSE)),0)","v":0},{"$f":"TRUNC(IF(I_15,((I12*E12)+(H12*G12))*1.15,IF(I_30,((I12*E12)+(H12*G12))*1.3,IF(I_No,((I12*E12)+(H12*G12)),IF(AND(Instructions!K14<>\"LEED v4.1\",credit=1),((I12*E12)+(H12*G12))*1.3,((I12*E12)+(H12*G12)))))),2)","v":0},null,{"$f":"IFERROR(J12/K12,0)","v":0},null,null,{"$f":"IFERROR(IF(Instructions!$N$169=1,($Q12/1000)*$E12,($Q12/100)*$E12),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($D12,Instructions!$C$76:$K$160,9,FALSE),0)","v":0}]
[{"$f":"IF(B13=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(D13,Instructions!$C$76:$K$160,5,FALSE),VLOOKUP(D13,Instructions!$C$76:$K$160,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$169=1,VLOOKUP(D13,Instructions!$C$76:$K$160,7,FALSE),VLOOKUP(D13,Instructions!$C$76:$K$160,8,FALSE)),0)","v":0},{"$f":"TRUNC(IF(I_15,((I13*E13)+(H13*G13))*1.15,IF(I_30,((I13*E13)+(H13*G13))*1.3,IF(I_No,((I13*E13)+(H13*G13)),IF(AND(Instructions!K14<>\"LEED v4.1\",credit=1),((I13*E13)+(H13*G13))*1.3,((I13*E13)+(H13*G13)))))),2)","v":0},null,{"$f":"IFERROR(J13/K13,0)","v":0},null,null,{"$f":"IFERROR(IF(Instructions!$N$169=1,($Q13/1000)*$E13,($Q13/100)*$E13),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($D13,Instructions!$C$76:$K$160,9,FALSE),0)","v":0}]

{"sheet":"Summary","index":4,"n_rows":21,"n_cols":22,"rows_kept":21,"cut":false,"hidden":false,"merged":[[7,19,9,19],[7,14,9,14],[7,15,9,15],[7,16,9,16],[7,18,9,18],[7,10,8,10],[7,11,9,11],[20,3,20,6],[7,3,9,3],[7,4,9,4],[7,5,9,5],[7,6,9,6]]}
[]
[null,null,1]
[null,null,1,"Summary"]
[null,null,1,"Note: All information on this tab is READ-ONLY. To edit, see the previous tab(s). "]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,1,null,"Show simple view"]
[null,null,1]
[null,null,1,"System Name \nand Number","System \nType","All zones included \nin the VRP calculation?","Condition\nAnalyzed","System \nFloor Area","System Population",{"$f":"IF(I_15,\"Outdoor Air Intake Flow (15% above 62.1 requirement)\",IF(I_30,\"Outdoor Air Intake Flow (30% above 62.1 requirement)\",IF(I_No,\"Outdoor Air Intake Flow (required by 62.1)\",IF(AND(Instructions!K14<>\"LEED v4.1\",credit=1),\"Outdoor Air Intake Flow (30% above 62.1 requirement)\",\"Outdoor Air Intake Flow (required by 62.1)\"))))","v":"Outdoor Air Intake Flow (required by 62.1)"},"Outdoor Air Intake Flow Provided\n(measured or design)","Outdoor air \nintake flow provided \nmeets or exceeds Vot?","People \nOutdoor \nAir Rate for System","Area\nOutdoor\nAir Rate for System","Occupant Diversity\nD","Average \nZone Air Distribution Effectiveness\nEz average","Ventilation\nEfficiency\nEv","System \nPrimary Airflow \n(at condition analyzed)","Average Outdoor Air Fraction\nXs","Zone outdoor airflow provided meets or exceeds Voz for all zones?"]
["B",null,null,null,null,null,null,"As","Ps","Vot",null,null,"Rp system","Ra system",null,null,null,"Vps"]
[null,null,1,null,null,null,null,{"$f":"IF(Instructions!$N$169=2,\"(sq m)\",\"(sq ft)\")","v":"(sq ft)"},"(people)",{"$f":"IF(Instructions!$N$169=2,\"(L/s)\",\"(cfm)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$169=2,\"(L/s)\",\"(cfm)\")","v":"(cfm)"},null,{"$f":"IF(Instructions!$N$169=1,Instructions!$G$75,Instructions!$H$75)","v":"(cfm per person)"},{"$f":"IF(Instructions!$N$169=1,Instructions!$I$75,Instructions!$J$75)","v":"(cfm per sq ft) "},null,null,null,{"$f":"IF(Instructions!$N$169=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"}]
[null,null,null,"Single Zone Systems"]
[null,null,null,{"$f":"'Single Zone'!$B12","v":0},{"$f":"'Single Zone'!$B$2","v":"Single zone"},{"$f":"IF(E12=\"Single zone\",\"n/a\",\"\")","v":"n/a"},{"$f":"'Single Zone'!$C12","v":0},{"$f":"'Single Zone'!$E12","v":0},{"$f":"'Single Zone'!G12","v":0},{"$f":"ROUND('Single Zone'!L12,0)","v":0},{"$f":"ROUND('Single Zone'!M12,0)","v":0},{"$f":"IF(AND(K12>0,J12>0,K12>=J12),\"Yes\",\"No\")","v":"No"},{"$f":"'Single Zone'!H12","v":0},{"$f":"'Single Zone'!I12","v":0},{"$f":"IF($E12=\"Single zone\",\"n/a\",\"\")","v":"n/a"},{"$f":"'Single Zone'!K12","v":0},{"$f":"IF($E12=\"Single zone\",\"n/a\",\"\")","v":"n/a"},"n/a","n/a",{"$f":"IF(E12=\"Single zone\",\"n/a\",\"\")","v":"n/a"}]
[null,null,null,{"$f":"'Single Zone'!$B13","v":0},{"$f":"'Single Zone'!$B$2","v":"Single zone"},{"$f":"IF(E13=\"Single zone\",\"n/a\",\"\")","v":"n/a"},{"$f":"'Single Zone'!$C13","v":0},{"$f":"'Single Zone'!$E13","v":0},{"$f":"'Single Zone'!G13","v":0},{"$f":"ROUND('Single Zone'!L13,0)","v":0},{"$f":"ROUND('Single Zone'!M13,0)","v":0},{"$f":"IF(AND(K13>0,J13>0,K13>=J13),\"Yes\",\"No\")","v":"No"},{"$f":"'Single Zone'!H13","v":0},{"$f":"'Single Zone'!I13","v":0},"n/a",{"$f":"'Single Zone'!K13","v":0},"n/a","n/a","n/a",{"$f":"IF(E13=\"Single zone\",\"n/a\",\"\")","v":"n/a"}]
[]
[null,null,null,"Multiple Zone Systems"]
[null,null,{"$f":"IFERROR(IF(OR(,D16=\"Multiple Zone\",D16=\"100% OA\",D16=\"Summary\",D16=\"Single Zone\",E16=\"100% Outdoor Air\"),0,1),0)","v":0},{"$f":"INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A1),1)","v":{"$error":"#NAME?"}},{"$f":"INDIRECT(\"'\"&D16&\"'!$B$2\")","v":{"$error":"#VALUE!"}},{"$f":"IF(E16=\"Multiple Zone\",INDIRECT(\"'\"&D16&\"'!$D$8\"),\"n/a\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D16&\"'!$D$7\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D16&\"'!$Z$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D16&\"'!$AA$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D16&\"'!$AI$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D16&\"'!$AJ$3\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(K16>0,J16>0,K16>=J16),\"Yes\",\"No\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D16&\"'!$AB$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D16&\"'!$AC$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D16&\"'!$AD$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D16&\"'!$AE$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D16&\"'!$AF$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D16&\"'!$AG$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D16&\"'!$AH$3\")","v":{"$error":"#VALUE!"}},"n/a"]
["A"]
[null,null,null,"100% Outdoor Air Systems"]
[null,null,{"$f":"IFERROR(IF(OR(D19=\"Multiple Zone\",D19=\"100% OA\",D19=\"Summary\",D19=\"Single Zone\",E19=\"Multiple Zone\"),0,1),0)","v":0},{"$f":"INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A1),1)","v":{"$error":"#NAME?"}},{"$f":"INDIRECT(\"'\"&D19&\"'!$B$2\")","v":{"$error":"#VALUE!"}},{"$f":"IF(E19=\"Multiple Zone\",INDIRECT(\"'\"&D19&\"'!$D$8\"),\"n/a\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D19&\"'!$D$7\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D19&\"'!$Z$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D19&\"'!$AA$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D19&\"'!$AI$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D19&\"'!$AJ$3\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(K19>0,J19>0,K19>=J19),\"Yes\",\"No\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D19&\"'!$AB$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D19&\"'!$AC$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D19&\"'!$AD$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D19&\"'!$AE$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D19&\"'!$AF$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D19&\"'!$AG$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&D19&\"'!$AH$3\")","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&$D19&\"'!AO7\")","v":{"$error":"#VALUE!"}}]
["C"]
[null,null,null,"Totals",null,null,null,{"$f":"SUM(H11:H20)","v":{"$error":"#VALUE!"}},{"$f":"SUM(I11:I20)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J11:J20)","v":{"$error":"#VALUE!"}},{"$f":"SUM(K11:K20)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"SUM(R11:R20)","v":{"$error":"#VALUE!"}}]